package mysql8学习.初级.第18章_MySQL8的其它新特性;

/**
 * 分类讲解
 *
 * 创建表：
 *
 * ```mysql
 * CREATE TABLE goods(
 *      id INT PRIMARY KEY AUTO_INCREMENT,
 *      category_id INT,
 *      category VARCHAR(15),
 *      NAME VARCHAR(30),
 *      price DECIMAL(10,2),
 *      stock INT,
 *      upper_time DATETIME
 * );
 * ```
 *
 * 添加数据：
 *
 * INSERT INTO goods(category_id,category,NAME,price,stock,upper_time)
 * VALUES
 * (1, '女装/女士精品', 'T恤', 39.90, 1000, '2020-11-10 00:00:00'),
 * (1, '女装/女士精品', '连衣裙', 79.90, 2500, '2020-11-10 00:00:00'),
 * (1, '女装/女士精品', '卫衣', 89.90, 1500, '2020-11-10 00:00:00'),
 * (1, '女装/女士精品', '牛仔裤', 89.90, 3500, '2020-11-10 00:00:00'),
 * (1, '女装/女士精品', '百褶裙', 29.90, 500, '2020-11-10 00:00:00'),
 * (1, '女装/女士精品', '呢绒外套', 399.90, 1200, '2020-11-10 00:00:00'),
 * (2, '户外运动', '自行车', 399.90, 1000, '2020-11-10 00:00:00'),
 * (2, '户外运动', '山地自行车', 1399.90, 2500, '2020-11-10 00:00:00'),
 * (2, '户外运动', '登山杖', 59.90, 1500, '2020-11-10 00:00:00'),
 * (2, '户外运动', '骑行装备', 399.90, 3500, '2020-11-10 00:00:00'),
 * (2, '户外运动', '运动外套', 799.90, 500, '2020-11-10 00:00:00'),
 * (2, '户外运动', '滑板', 499.90, 1200, '2020-11-10 00:00:00');
 * ```
 *
 */
public class C_窗口函数案例基础数据 {
}
